Leagues

var cid = '' var cGroupname = "" var nStatusCode = 0 var lContinue = true var groupname = request.groupname cursor1 = database.cursor("select * from settings") cursor1.next() week = cursor1.viewweek year = cursor1.viewyear cursor1.close() cursor1 = database.cursor("select * from groupm where groupname = '" + request.groupname + "'") cursor1.next() commissioner = cursor1.commissioner description = cursor1.description comments = cursor1.comments cursor1.close() writeln("") write("

"+request.groupname+" league

") writeln("

") write("Join League
") write("List Leagues
") write("Week "+week+" Standings
") write("Cumulative Standings
") write("Home Page") writeln("

") writeln("

") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("

League Name:	"+request.groupname+"
Commissioner:	"+commissioner+"
Description:	"+description+"
Commissioner Comments:	"+comments+"

") writeln("") writeln("

") writeln("Standings For Week "+week+"
") writeln("

") if (!database.connected()) { write("

Error: Database is not available.

") lContinue = false } if (lContinue) { writeln("") write("") write("") write("") write("") write("") write("") write("") cSql = "select week.id,esp,pda,wa,wpa,ups,status,groupd.alias,week.pos" cSql = cSql + " from groupd,week where groupd.groupname = '" cSql = cSql + request.groupname + "'" cSql = cSql + " and (week.year = '" + year + "') and (week.week = '" cSql = cSql + week + "') and (groupd.id = week.id)" cursor = database.cursor(cSql) while (cursor.next()) { cWkfile = "/fpc/" + year + week + "WK01.htm" lid = "/home/home.htm?id=" + cursor.id + "&&year=" + year cBlank = '' cPda = cBlank + cursor.pda cPda = real(cPda,1) cWa = cBlank + cursor.wa cWa = real(cWa,1) cWpa = cBlank + cursor.wpa cWpa = real(cWpa,1) cUps = cBlank + cursor.ups cUps = real(cUps,2) cStatus = cBlank + cursor.status cStatus = real(cStatus,2) write("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") writeln("") } write("

ALIAS	POS	ESP	PDA	WA	WPA	UPS	STATUS
" + cursor.alias + "	"+cursor.pos+"	"+cursor.esp+"	"+cPda+"	"+cWa+"	"+cWpa+"	"+cUps+"	"+cStatus+"

") write("") cursor.close() lf = unescape("%0A") }